/*
 Navicat Premium Data Transfer

 Source Server         : 阿里云服务器：SQL Server
 Source Server Type    : SQL Server
 Source Server Version : 13005026
 Source Host           : 121.40.101.29:1433
 Source Catalog        : scm_main_sfl202004091645new
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 13005026
 File Encoding         : 65001

 Date: 11/09/2020 09:19:13
*/


-- ----------------------------
-- Table structure for t_token
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_token]') AND type IN ('U'))
	DROP TABLE [dbo].[t_token]
GO

CREATE TABLE [dbo].[t_token] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [adhibition_name] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [access_token] varchar(1000) COLLATE Chinese_PRC_CI_AS  NULL,
  [expires_in] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [createTime] datetime  NULL
)
GO

ALTER TABLE [dbo].[t_token] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Primary Key structure for table t_token
-- ----------------------------
ALTER TABLE [dbo].[t_token] ADD CONSTRAINT [PK__t_token__3213E83F18DCB5F2] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

